package dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class CMonthArrangeIDMemoryDAO {
	
	
	public int increaseCMonthArrangeID(Statement statement) throws SQLException {
		ResultSet rs;
		
		int nCMonthArrangeID = 0;
		rs = statement.executeQuery("select * from cmontharrangeidmemory");
		rs.next();
		nCMonthArrangeID = rs.getInt(1);
	
		statement.execute("update cmontharrangeidmemory set CMonthArrangeID=CMonthArrangeID+1");
		
		return nCMonthArrangeID;
	}
}
